How to: Search and replace selected data in a table.
Solution:
Select the 'Edit' menu and select 'Replace...', type what to search for in the 'Find What' box, and click 'Find First'.
1) If the Database window is not active, activate the Database window.
2) Open the table in the Table Datasheet view.
3) Select the 'Edit' menu and select 'Replace...'. (The Replace dialog box appears.)
4) Type what to search for in the 'Find What' box.
Find What box
5) Type what to replace the data with in the 'Replace With' box.
Replace With box
6) Make sure the 'Search Only Current Field' check box is NOT checked.
Search Only Current Field
7) (Optional) Select any other desired check boxes.
8) Click 'Find Next'. (The first record meeting the criteria typed in step 4) is found.)
9) When a match is found, do one of the following:
a) Click 'Replace' to replace the single occurrence of the data.
b) Click 'Replace All' to replace all occurrences of the data.
c) Click 'Close' to close the 'Find' dialog box and make other changes to the data found.
10) To find additional records with the same criteria:
a) (Special Case) If 'Close' was chosen in step 9), select the 'Edit' menu and select 'Find'. (The Find dialog box appears, with the same criteria still in the Find What box.)
b) Repeat steps 8) and 9).
c) Repeat steps 10)a) through 10)c) for each additional record meeting the criteria.
11) Click 'Close' to close the 'Replace' dialog box.
